SQL Notes

Browser execution note: Most SELECT queries in this section can now run directly in the browser against an in-memory SQLite database with preloaded sample data such as customers, orders, and Sales.* tables. SQL Server setup scripts and T-SQL-specific syntax are still reference-only. That includes commands and features like GO, USE, CREATE DATABASE, ALTER DATABASE, DROP DATABASE, and some SQL Server-only functions such as FORMAT().

Table of Content

• Introduction
  • Examples & Sample Data
    • SELECT Query
    • Data Definition Language (DDL)
    • Data Manipulation (DML)
    • Filtering Data
  • JOIN And SET
    • JOIN Query
    • SET Query
  • ROW Level Functions
    • String Functions Examples
    • Number Functions Examples
    • Date and Time Functions Examples
    • Date and Time Formats Examples
    • NULL Functions Examples
    • CASE Statements Examples
  • Aggregation Analytical Functions
    • Aggregate Functions
    • Window Functions Basics Examples
    • Window Aggregations Examples
    • Window Ranking Functions Examples
    • Window Value Functions Examples